CREATE  PROCEDURE [dbo].[asi_InstitutesFromIndividualByType]
    @institutegrouptypekey uniqueidentifier,
    @individualkey uniqueidentifier
AS
BEGIN
select vBoInstitute.ContactKey from vBoInstitute
    where vBoInstitute.InstituteGroupKey in
        (select    vBoGroup.GroupKey from vBoGroup inner join GroupMember
            on vBoGroup.GroupKey = GroupMember.GroupKey
            where GroupMember.MemberContactKey = @individualkey and
                           vBoGroup.GroupTypeKey = @institutegrouptypekey)
END

GO